Tabela TreatmentSchemaDef

Definicja tabeli TreatmentSchemaDef

Name

TreatmentSchemaDef

Code

TreatmentSchemaDef

Comment

Schematy leczenia


Lista kolumn tabeli TreatmentSchemaDef

Name

Code

TreatmentSchemaDefID

TreatmentSchemaDefID

Code

Code

FullName

FullName

Description

Description

StartDT

StartDT

StopDT

StopDT

Active

Active


Kolumna TreatmentSchemaDefID tabeli TreatmentSchemaDef

Definicja kolumny TreatmentSchemaDefID tabeli TreatmentSchemaDef

Name

TreatmentSchemaDefID

Code

TreatmentSchemaDefID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID schematu leczenia


Kolumna Code tabeli TreatmentSchemaDef

Definicja kolumny Code tabeli TreatmentSchemaDef

Name

Code

Code

Code

Data Type

VARCHAR2(13)

Mandatory

No

Comment

Kod schematu


Kolumna FullName tabeli TreatmentSchemaDef

Definicja kolumny FullName tabeli TreatmentSchemaDef

Name

FullName

Code

FullName

Data Type

VARCHAR2(255)

Mandatory

Yes

Comment

Nazwa schematu


Kolumna Description tabeli TreatmentSchemaDef

Definicja kolumny Description tabeli TreatmentSchemaDef

Name

Description

Code

Description

Data Type

CLOB

Mandatory

No

Comment

Opis schematu


Kolumna StartDT tabeli TreatmentSchemaDef

Definicja kolumny StartDT tabeli TreatmentSchemaDef

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

Data poczatku obowiazywania definicji


Kolumna StopDT tabeli TreatmentSchemaDef

Definicja kolumny StopDT tabeli TreatmentSchemaDef

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

Data konca obowiazywania definicji


Kolumna Active tabeli TreatmentSchemaDef

Definicja kolumny Active tabeli TreatmentSchemaDef

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

Flaga aktywnosci


Lista kluczy tabeli TreatmentSchemaDef

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli TreatmentSchemaDef

Definicja klucza Identifier_1 tabeli TreatmentSchemaDef

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment